import xlrd

def getExcelData(fileName,sheetName):
    myexcel = xlrd.open_workbook(fileName)
    mysheet  =myexcel.sheet_by_name(sheetName)
    rows = mysheet.nrows
    cols = mysheet.ncols
    dataList = []
    for i in range(rows):
        templist=[]
        for f in range(cols):
            temp=mysheet.cell_value(i,f)
            templist.append(temp)
        dataList.append(templist)
    return dataList


if __name__ == '__main__':
    print(getExcelData("./MyKongfz.xlsx", 'Sheet1'))